<%@ page import="java.sql.*, studentportal.*"%>
<%@taglib uri="http://java.sun.com/jstl/core" prefix="c"%>
<html>
 
<body background="indtextb.jpg" bgcolor="#FFFFFF" text="#000000" link="#3366CC" vlink="#666666" alink="#996600">

<table border="0" width="100%" bordercolorlight="#666666" bordercolordark="#000000">
  <tr>
    <td width="100%"><img border="0" src="StdPrtlbanner.jpg" width="846" height="65">&nbsp;</td>
  </tr>
</table>
<table border="0" align="center" width="100%" bordercolorlight="#666666" bordercolordark="#000000">
  <tr>
    <td width="10%">
      <a href="Student_Persanal_InfoView.jsp">Personal Info</a></td>
    <td width="10%">
      <a href="Student_Course_InfoView.jsp">Course Info</a></td>
    <td width="10%">
      <a href="Student_Notes_InfoView.jsp">Notes Info</a></td>
    <td width="10%">
      <a href="Student_Assignment_InfoView.jsp">Assignment Info</a></td>

    <td width="10%">
      <a href="Student_Book.jsp">Books</a></td>
    <td width="10%">
      <a href="Student_Notification.jsp">Notifications</a></td>
    <td width="10%">
      <a href="Student_Security_InfoView.jsp">Security</a></td>
    <td width="10%">
      <a href="Home.html">Home</a></td>
  </tr>
</table>

<%
					
					Connection con=MySQLDriver.getConnection(); 
					Statement st=con.createStatement();
					System.out.println("After Statement");
					String sid=(String)session.getAttribute("StudentId");
					System.out.println("STRING"+sid);
					String str="select course_master.*,semister_master.*,subject_master.* from student_master, course_master, semister_master,subject_master where student_master.course_id=course_master.course_id and course_master.course_id=semister_master.academic_year and subject_master.semister_id=semister_master.semister_id and student_id='"+sid+"'";
					ResultSet rs=st.executeQuery(str);
					if(rs.next()) {
					//Student stu=(Student)session.getAttribute("Student");
%>
<p align="center">&nbsp;</p>
<form method="POST" action="./StudentRegServlet">
 
  <div align="center">
    <center>


    <table border="1" width="68%" bordercolor="#0000FF">
      <tr>
        <td width="100%" colspan="5">
          <p align="center"><b><font size="4" color="#008000">Student Assignment Information</font></b></td>
      </tr>
    </center>
    <tr>
      <td valign="center" align="left">
        <p align="center">Semister Name</td>
      <td valign="center" align="left">
        <p align="center">Start Date</td>
      <td valign="center" align="left">
        <p align="center">End Date</td>
      <td valign="center" align="left">
        <p align="center">Subject Name</td>
      <td valign="center" align="left">
        <p align="center">View Assignment</td>
      </tr>
      
    <tr>
      <td valign="center" align="left">
        <p align="left"><%=rs.getString(9)%></td>
      <td valign="center" align="left">
        <p align="left"><%=rs.getString(11)%></td>
      <td valign="center" align="left">
        <p align="left"><%=rs.getString(12)%></td>
      <td valign="center" align="left">
        <p align="left"><%=rs.getString(15)%></td>
      <td valign="center" align="left">
        <p align="left"><a href="StudentListAssignment.jsp?ID=<%=rs.getString(14)%>">View</a></td>
    </tr>
<%     while(rs.next()) { %>
    <tr>
      <td valign="center" align="left">
        <p align="left"><%=rs.getString(9)%></td>
      <td valign="center" align="left">
        <p align="left"><%=rs.getString(11)%></td>
      <td valign="center" align="left">
        <p align="left"><%=rs.getString(12)%></td>
      <td valign="center" align="left">
        <p align="left"><%=rs.getString(15)%></td>
      <td valign="center" align="left">
        <p align="left"><a href="StudentListAssignment.jsp?ID=<%=rs.getString(14)%>">View</a></td>
    </tr>
    <%} %>
    </center>
    </table>
    </center>
  </div>
</form>
<p align="left">&nbsp;</p>
<%}rs.close(); st.close(); con.close();%>

</body>

</html>
